{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Disclaimer","ISD-StopSignal","ISD-No Traffic Control"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,3,25,8],[21,10,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[]
[null,null,null,"This Design Calculation Spreadsheet is provided \"as-is\" without warranty of any kind. The Montana Department of Transportation makes no representations or warranties whatsoever with respect to the accuracy or completeness of this tool and assumes no responsibility for the suitability of this tool for a particular purpose; and MDT will not be liable for any damages incurred as a result of errors in this tool. \n\nBy selecting Accept, you are agreeing to these terms and conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WARNING: \nFor the tool to work properly, please make sure you click on \"Enable Content/Macros\" if the security warning appears."]

{"sheet":"ISD-StopSignal","index":1,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":true,"merged":[[43,2,43,4],[1,5,2,5],[1,17,2,17],[1,21,2,21],[1,19,2,19],[1,18,2,18],[22,3,24,7],[31,2,31,4],[32,2,32,4],[1,3,2,3],[1,15,2,15],[1,11,2,11],[1,20,2,20],[1,4,2,4],[1,6,2,6],[1,7,2,7],[33,2,33,4],[41,2,41,4],[42,2,42,4],[1,16,2,16],[1,12,2,12],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,13,2,13],[1,14,2,14]]}
["Intersection Sight Distance (ISD) - Stop Controlled/Traffic Signal Controlled"]
[null,null,null,"Approach Station or Description","Number of Crossed Lanes to Turn Left*","Number of Lanes for Crossing Maneuver","Approach Grade (%)","Design Vehicle","Left-Turn tg base (sec)","Left-Turn tg lanes (sec)","Left-Turn tg appr. (sec)","Left-Turn tg (sec)","Left-Turn ISD (ft)","Right-Turn tg base (sec)","Right-Turn tg appr. (sec)","Right-Turn tg (sec)","Right-Turn ISD (ft)","Crossing tg base (sec)","Crossing tg lanes (sec)","Crossing tg appr. (sec)","Crossing tg (sec)","Crossing ISD (ft)"]
["Design Speed (Vmajor) =",null,"mph"]
[null,null,null,null,null,null,null,null,{"$f":"IF($E4=\"\",\"\",LOOKUP($H4,$C$28:$C$30,$D$28:$D$30))","v":""},{"$f":"IF(OR($E4=\"\",$E4=1),\"\",IF(E4>1,IF($H4=\"Passenger Car\",ROUND(0.5*($E4-1),1),IF($H4=\"Single-Unit Truck\",ROUND(0.7*($E4-1),1),IF($H4=\"Tractor/Semitrailer\",\"\")))))","v":""},{"$f":"IF($G4<=3,\"\",IF($G4>3,ROUND(0.2*$G4,1)))","v":""},{"$f":"IF($E4=\"\",\"\",SUM(I4:K4))","v":""},{"$f":"IF(L4=\"\",\"\",ROUND(1.47*$B$3*L4,0))","v":""},{"$f":"IF($E4=\"\",\"\",LOOKUP($H4,$C$28:$C$30,$E$28:$E$30))","v":""},{"$f":"IF($G4<=3,\"\",IF($G4>3,ROUND(0.1*$G4,1)))","v":""},{"$f":"IF($E4=\"\",\"\",SUM(N4:O4))","v":""},{"$f":"IF(P4=\"\",\"\",ROUND(1.47*$B$3*P4,0))","v":""},{"$f":"IF($F4=\"\",\"\",LOOKUP($H4,$C$38:$C$40,$D$38:$D$40))","v":""},{"$f":"IF(OR($F4=\"\",$F4=2),\"\",IF($F4>1,IF($H4=\"Passenger Car\",ROUND(0.5*($F4-2),1),IF($H4=\"Single-Unit Truck\",ROUND(0.7*($F4-1),1),IF($H4=\"Tractor/Semitrailer\",\"\")))))","v":""},{"$f":"IF($G4<=3,\"\",IF($G4>3,ROUND(0.2*$G4,1)))","v":""},{"$f":"IF($F4=\"\",\"\",SUM(R4:T4))","v":""},{"$f":"IF(U4=\"\",\"\",ROUND(1.47*$B$3*U4,0))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E5=\"\",\"\",LOOKUP($H5,$C$28:$C$30,$D$28:$D$30))","v":""},{"$f":"IF(OR($E5=\"\",$E5=1),\"\",IF(E5>1,IF($H5=\"Passenger Car\",ROUND(0.5*($E5-1),1),IF($H5=\"Single-Unit Truck\",ROUND(0.7*($E5-1),1),IF($H5=\"Tractor/Semitrailer\",\"\")))))","v":""},{"$f":"IF($G5<=3,\"\",IF($G5>3,ROUND(0.2*$G5,1)))","v":""},{"$f":"IF($E5=\"\",\"\",SUM(I5:K5))","v":""},{"$f":"IF(L5=\"\",\"\",ROUND(1.47*$B$3*L5,0))","v":""},{"$f":"IF($E5=\"\",\"\",LOOKUP($H5,$C$28:$C$30,$E$28:$E$30))","v":""},{"$f":"IF($G5<=3,\"\",IF($G5>3,ROUND(0.1*$G5,1)))","v":""},{"$f":"IF($E5=\"\",\"\",SUM(N5:O5))","v":""},{"$f":"IF(P5=\"\",\"\",ROUND(1.47*$B$3*P5,0))","v":""},{"$f":"IF($F5=\"\",\"\",LOOKUP($H5,$C$38:$C$40,$D$38:$D$40))","v":""},{"$f":"IF(OR($F5=\"\",$F5=2),\"\",IF($F5>1,IF($H5=\"Passenger Car\",ROUND(0.5*($F5-2),1),IF($H5=\"Single-Unit Truck\",ROUND(0.7*($F5-1),1),IF($H5=\"Tractor/Semitrailer\",\"\")))))","v":""},{"$f":"IF($G5<=3,\"\",IF($G5>3,ROUND(0.2*$G5,1)))","v":""},{"$f":"IF($F5=\"\",\"\",SUM(R5:T5))","v":""},{"$f":"IF(U5=\"\",\"\",ROUND(1.47*$B$3*U5,0))","v":""}]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","",""]
[null,null,null,"*Number of Lanes on major roadway to the nearest lane to turn left (e.g. for a 4-lane facility with two travel lanes in each direction this value would be 2, for a two-lane roadway it would be 1). See Adjustment #2 below for median width to lane width.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($F23=\"\",$F23=2),\"\",IF($F23>1,IF($H23=\"Passenger Car\",ROUND(0.5*($E23-2),1),IF($H23=\"Single-Unit Truck\",ROUND(0.7*($E23-1),1),IF($H23=\"Tractor/Semitrailer\",\"\")))))","v":""},{"$f":"IF($G23<=3,\"\",IF($G23>3,ROUND(0.2*$G23,1)))","v":""},null,{"$f":"IF(U23=\"\",\"\",ROUND(1.47*$B$3*U23,0))","v":""}]
[]
[]
[null,null,"RDM Exhibit F-10"]
[null,null,"Design Vehicle","Left-Turn from Stop, Gap Acceptance Time (tg) (sec)","Right-Turn from Stop, Gap Acceptance Time (tg) (sec)"]
[null,null,"Passenger Car",7.5,6.5]
[null,null,"Single-Unit Truck",9.5,8.5]
[null,null,"Tractor/Semitrailer",11.5,10.5]
[null,null,"Adjustments:"]
[null,null,"1. Multilane Highway. For left-turns onto multilane highways, add 0.5 seconds for passenger cars or 0.7 seconds for trucks for each additional lane, in excess of one, to be crossed by the turned vehicle. No adjustments for right-turns onto multilane highways."]
[null,null,"2. Medians. For a multilane facility which does not have a median wide enough to store a stopped vehicle, divide the median width by 12' to determine the corresponding number of lanes, and then use criteria in Adjustment 1 above. On multilane facilities with a median wide enough to store the stopped vehicle, the design team should evaluate the move in two steps (Exhibit F-13)."]
[null,null,"3. Approach Grade. If the approach grade on the minor road exceeds +3% upgrade, multiply the percent grade of the minor road approach by 0.2 for left turns or 0.1 for right turns and add it to the base gap acceptance time. This does not apply if the approach grade is negative."]
[]
[null,null,"RDM Exhibit F-10"]
[null,null,"Design Vehicle","Crossing Maneuver, Gap Acceptance Time (tg) (sec)"]
[null,null,"Passenger Car",6.5]
[null,null,"Single-Unit Truck",8.5]
[null,null,"Tractor/Semitrailer",10.5]
[null,null,"Adjustments:"]
[null,null,"4. Multilane Highway. Where the design vehicle is crossing a major road with more than two lanes, add 0.5 seconds for passenger cars or 0.7 seconds for trucks for each additional lane, in excess of two."]
[null,null,"2. Medians. Where medians are present, divide this width by 12 feet to determine the corresponding number of lanes for the crossing maneuver."]
[null,null,"3. Approach Grade. If the approach grade on the minor road exceeds +3% upgrade, multiply the percent grade of the minor road approach by 0.2 and add it to the base gap acceptance time. This does not apply if the approach grade is negative."]

{"sheet":"ISD-No Traffic Control","index":2,"n_rows":11,"n_cols":21,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,10,1,20],[1,9,2,9],[1,6,2,6],[1,7,2,7]]}
["Intersection Sight Distance (ISD) - No Traffic Control (AASHTO Case A)"]
["Approach Station or Description","Design Speed (mph)","Approach Grade\n(%)","Intersection Sight Distance (ft)","Approach Factors",null,"Design Speed (mph)","ISD (ft)",null,"Approach Grade (%)","Design Speed (mph)"]
[null,null,null,{"$f":"IF(B3=\"\",\"\",LOOKUP(B3,$G$4:$G$11,$H$4:$H$11))","v":""},{"$f":"IF(C3=\"\",\"\",IF(AND(C3>=-3,C3<=3),1,IF(B3=$G$4,1,IF(B3=$K3,LOOKUP($C3,$J$4:$J$11,$K$4:$K$11),IF(B3=$L$3,LOOKUP($C3,$J$4:$J$11,$L$4:$L$11),IF(B3=$M$3,LOOKUP($C3,$J$4:$J$11,$M$4:$M$11),IF(B3=$N$3,LOOKUP($C3,$J$4:$J$11,$N$4:$N$11),IF(B3=$O$3,LOOKUP($C3,$J$4:$J$11,$O$4:$O$11),IF(B3=$P$3,LOOKUP($C3,$J$4:$J$11,$P$4:$P$11),IF(B3=$Q$3,LOOKUP($C3,$J$4:$J$11,$Q$4:$Q$11),IF(B3=$R$3,LOOKUP($C3,$J$4:$J$11,$R$4:$R$11),IF(B3=$S$3,LOOKUP($C3,$J$4:$J$11,$S$4:$S$11),IF(B3=$T$3,LOOKUP($C3,$J$4:$J$11,$T$4:$T$11),IF(B3=$U$3,LOOKUP($C3,$J$4:$J$11,$U$4:$U$11)))))))))))))))","v":""},null,null,null,null,null,20,25,30,35,40,45,50,55,60,65,70]
[null,null,null,{"$f":"IF(B4=\"\",\"\",LOOKUP(B4,$G$4:$G$11,$H$4:$H$11))","v":""},{"$f":"IF(C4=\"\",\"\",IF(AND(C4>=-3,C4<=3),1,IF(B4=$G$4,1,IF(B4=$K4,LOOKUP($C4,$J$4:$J$11,$K$4:$K$11),IF(B4=$L$3,LOOKUP($C4,$J$4:$J$11,$L$4:$L$11),IF(B4=$M$3,LOOKUP($C4,$J$4:$J$11,$M$4:$M$11),IF(B4=$N$3,LOOKUP($C4,$J$4:$J$11,$N$4:$N$11),IF(B4=$O$3,LOOKUP($C4,$J$4:$J$11,$O$4:$O$11),IF(B4=$P$3,LOOKUP($C4,$J$4:$J$11,$P$4:$P$11),IF(B4=$Q$3,LOOKUP($C4,$J$4:$J$11,$Q$4:$Q$11),IF(B4=$R$3,LOOKUP($C4,$J$4:$J$11,$R$4:$R$11),IF(B4=$S$3,LOOKUP($C4,$J$4:$J$11,$S$4:$S$11),IF(B4=$T$3,LOOKUP($C4,$J$4:$J$11,$T$4:$T$11),IF(B4=$U$3,LOOKUP($C4,$J$4:$J$11,$U$4:$U$11)))))))))))))))","v":""},null,15,70,null,-6,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.2,1.2,1.2,1.2,1.2]
[null,null,null,null,null,null,20,90,null,-5,1,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.2,1.2]
[null,null,null,null,null,null,25,115,null,-4,1,1,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001]
[null,null,null,null,null,null,30,140,null,-3,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,35,165,null,3,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,40,195,null,4,1,1,1,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]
[null,null,null,null,null,null,45,220,null,5,1,1,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]
[null,null,null,null,null,null,50,245,null,6,1,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]